Total customers

Quantity of customers who visited platform more 1 time

Customers distribution by country


As we can see from this map, most of google merchandise are customers located in USA.

 Lets Examine Google USA merchandise market 

Now lets find revenue/total customers in state ratio

Examine consumer basket and clients in Illinois state and clients

Comparing to total revenue by state(Where California customers bring biggest value), People in Illinois tend to buy more expensive items or there are outliers in Illinois(smaller number of customers with 1 outlier)

Lets find out what are most popular items in Illinois and California

Comparing consumer busket and spendings in Illinois/California that day, people in Illinois spent more money on Apparel/Bags then people in California.

People in California spent more money in Notebooks/Journals, Drinkware and Office stuff.

Lets find out most popular(Viewed) product by state

Have no idea how to vizualize it :) but the usage of window functions looks cool


Most purchased item by State

Conclusion :

We examined google store anaytics data on August, 1.

  1. Consumer distribution by country. Major clients are located in USA/India/Europe
  2. We looked closer at consumer distribution by state in USA. California(Google Headquartes Mountain View) biggest region by revenue, but it turned out that 1 customer(outlier) spent significatly more money.
  3. Consumer buying trends are different in Illinois/California. Need more observations to say for sure.